UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/3DeEy033PZL7f2zRgts45iISVlNErr73dHitwhKCmY='
WHERE
key_id = 'ecaf7af99364d0667064d4dc1a54b7b3879bf34498e8c7fd0ba12b5a49c5854d'
AND (
token = '/3DeEy033PZL7f2zRgts45iISVlNErr73dHitwhKCmY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)