UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qUUbPE3wEit2cpXt30sY1nq/cqCxKarZo779iiOdhbw='
WHERE
key_id = 'cf48b141b8a37e3d29d24852e03f29ab00fc5112aafef36cc391e37215fca9eb'
AND (
token = 'qUUbPE3wEit2cpXt30sY1nq/cqCxKarZo779iiOdhbw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)