UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qwmi/fIGdD1K0FVNiOBvHe+wnpLT+ofr/QROeK/V+sg='
WHERE
key_id = '3e2ae6e17903109bf14203a577caf3be0f00ea5e7ef114997dd204259708d366'
AND (
token = 'Qwmi/fIGdD1K0FVNiOBvHe+wnpLT+ofr/QROeK/V+sg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)