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