UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3TOce678o1y//YKiC5gRvfSR5XsKSoIJ0MoOI/EOuRo='
WHERE
key_id = 'fc994a478284474e441f692f1c36160d85070c802fa5f1a559a3dff7ddfac3c5'
AND (
token = '3TOce678o1y//YKiC5gRvfSR5XsKSoIJ0MoOI/EOuRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)