UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm1I4jLi6OBwFPqPobocdwmkQKrQ9ePzrsIAHu/LlBOs='
WHERE
key_id = 'a8f97a23c34c0d87485a626d288535a5a57770c30c451c5d99047500123d0f9d'
AND (
token = 'm1I4jLi6OBwFPqPobocdwmkQKrQ9ePzrsIAHu/LlBOs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)