UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QL7e41/ASu02yuhlh54Hx+eokiRb2dstprrIXrwo/Cw='
WHERE
key_id = 'd4ce8c072a71ed935cca7b0b6922eb0f031da3686a16d2db34d9097aea7de036'
AND (
token = 'QL7e41/ASu02yuhlh54Hx+eokiRb2dstprrIXrwo/Cw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)