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