UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PD/ssaiuyA0/2ZX7YJk+m4wEF8kp9L4vYr9sORi9ryo='
WHERE
key_id = 'fefd269748de1ebf33337f0cc26916b581213feadbca4e65be89b97588b550ac'
AND (
token = 'PD/ssaiuyA0/2ZX7YJk+m4wEF8kp9L4vYr9sORi9ryo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)