UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WeW7S2CrpeOJJZ2b0uqsdJN5m7N4+8k5fSdTUnm81f8='
WHERE
key_id = 'c0414ccd4dc1b1a48396be5db47f3b8c4825bf22f4369c211366cfa708ffbad1'
AND (
token = 'WeW7S2CrpeOJJZ2b0uqsdJN5m7N4+8k5fSdTUnm81f8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)