UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y8oTjewqo4qprhIGwUHWjtldxm1CJktfgS432UAiDwM='
WHERE
key_id = '7c6c2f1882093c7d3f8925715e7175b74dcdf77263ecff33a5741b50e0c6434b'
AND (
token = 'y8oTjewqo4qprhIGwUHWjtldxm1CJktfgS432UAiDwM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)