UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4mgprQZeWkr3okN4WChHW9dqv+d4Bmphojt6APlh6TM='
WHERE
key_id = '23aafb497d6db9a792631dc691346c13b25ac269dc70509e6c8253580a558e7c'
AND (
token = '4mgprQZeWkr3okN4WChHW9dqv+d4Bmphojt6APlh6TM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)