UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rj9ZbsfgGBbf9OsekK3M7HLt9DnTvUbH3RSQJZJsMFI='
WHERE
key_id = '99e5eedd88269699ea23971ff292ab9c6587d5c0dde0566ceee2b4cf5e1fdae5'
AND (
token = 'rj9ZbsfgGBbf9OsekK3M7HLt9DnTvUbH3RSQJZJsMFI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)