UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bO9Ggmvq5yf1bdK9L6WvdrWRpBgDLsQpo6794ifr7+k='
WHERE
key_id = 'ad5bf4e2aa0caf95c528749edae7feea4e489899524d7d2a1ec6532a29408c58'
AND (
token = 'bO9Ggmvq5yf1bdK9L6WvdrWRpBgDLsQpo6794ifr7+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)