UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KdG8RVy4OwZ9x5tA5xTdKgesctLYdDrkyUJAzd9mOQs='
WHERE
key_id = 'd7437c486dbe883915c9b8352b84f64e44970de5fe7bdb4978201b13c48fc5f9'
AND (
token = 'KdG8RVy4OwZ9x5tA5xTdKgesctLYdDrkyUJAzd9mOQs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)