UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pEKsKnbnyTDb8Mq8vDGotxLBN6r2fEfFW4xf18+H+c0='
WHERE
key_id = '0d6d04ee616a69b55422dbc9e9dde41d79a37938295772316ec1495e96e6cb9e'
AND (
token = 'pEKsKnbnyTDb8Mq8vDGotxLBN6r2fEfFW4xf18+H+c0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)