UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tjbK9cZXwgrkmjv3iWUai9KsRxnC9Yw8HEZCOxncvRM='
WHERE
key_id = '147d0279ea2371eb4277cfc3e2aa930475f43463f8877340bda65c81d9911b06'
AND (
token = 'tjbK9cZXwgrkmjv3iWUai9KsRxnC9Yw8HEZCOxncvRM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)