UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd10tqi2kMnPqVCkWFhOUTDeCYLsueON2Pus1uOxBBlw='
WHERE
key_id = 'f0bdd7e321855b2a9a2ab0eb9e1a657238b209471e9ec80f1d4d61dcbaf84dff'
AND (
token = 'd10tqi2kMnPqVCkWFhOUTDeCYLsueON2Pus1uOxBBlw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)