UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pXC8FM6bBfNJVHkOkqUn/pS45OdfK3eIFGr/RJEpmiM='
WHERE
key_id = '8597aca3e3e1a70d4a8b4f22348936634793723e4d588b954017ec3912d83153'
AND (
token = 'pXC8FM6bBfNJVHkOkqUn/pS45OdfK3eIFGr/RJEpmiM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)