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