UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XgtTiWWvhF58yqtEqNoPWDMfBM5jM+FPKp2K3l1cUps='
WHERE
key_id = 'decb5aa60534d6401ec64e255e7ebc19aab7556e2560540522456c2e6dd58e49'
AND (
token = 'XgtTiWWvhF58yqtEqNoPWDMfBM5jM+FPKp2K3l1cUps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)