UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NOn9l/E6DH+PGErcl7C4rqwIaZlKf3hJ4qU+72VAxVk='
WHERE
key_id = '0374fdc1c12e736936d7370dda01535e836a066e30434784e28e2499f0f273f4'
AND (
token = 'NOn9l/E6DH+PGErcl7C4rqwIaZlKf3hJ4qU+72VAxVk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)