UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KqN8rtsYzN60c5eVsZb018beIT6hK0YK4pzWTUXvsbA='
WHERE
key_id = 'b6d5f05034ac71897f2b48ceb45c552632aff785fc2d62b0f14b9daa35d2fbaa'
AND (
token = 'KqN8rtsYzN60c5eVsZb018beIT6hK0YK4pzWTUXvsbA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)