UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bRUG0nmXh72BzFTUOKcTsXwKCtgwQOD8GJtZe8+D13g='
WHERE
key_id = '9bbc93f0ce7a71f9c0b05737aac9519fde6f330b8757cb2b9ff7c61ccdff27ab'
AND (
token = 'bRUG0nmXh72BzFTUOKcTsXwKCtgwQOD8GJtZe8+D13g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)