UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C1DSctDCFNIdR99Br/2sZpHihbFtYzhTHeAd4brHSEw='
WHERE
key_id = 'fb38e547600f94c7d48d053f48b34d860502ce10b28dd6bbd6c87e5a8b1ee980'
AND (
token = 'C1DSctDCFNIdR99Br/2sZpHihbFtYzhTHeAd4brHSEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)