UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eCTGQKwXF+ZXlF/0Xjn/Rv5Zgmlqqr/aIa4+0kfJEOY='
WHERE
key_id = '50834ae469131052f092e473273c22908e6bf4799a765ed03f8ff4f19b9a846a'
AND (
token = 'eCTGQKwXF+ZXlF/0Xjn/Rv5Zgmlqqr/aIa4+0kfJEOY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)