UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HTQG/RqVgkuFKK3QEhN0o2+MfV+qjUKb2gWUupYYfOc='
WHERE
key_id = '220a9cf237a783dfdcaa3fd13832fb0a44a4925a52460a1714954a0351e81e15'
AND (
token = 'HTQG/RqVgkuFKK3QEhN0o2+MfV+qjUKb2gWUupYYfOc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)