UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xnw8bmKBBK0WBOWXiQgv0DMXlgUHebOOQn0f9cpxHf8='
WHERE
key_id = '9738a8de2ea75631504e82c8fccb3d7a1c9238cd697cb106821e129fb7ee7a8d'
AND (
token = 'xnw8bmKBBK0WBOWXiQgv0DMXlgUHebOOQn0f9cpxHf8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)