UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p8blxeIIM/b6mJb03N7OaiAd49GjCOnIkbumtTgali0='
WHERE
key_id = '7d1c0ae11774700321dd7a1e38e9945aac04939086d372ec3dab22e9cdab8acf'
AND (
token = 'p8blxeIIM/b6mJb03N7OaiAd49GjCOnIkbumtTgali0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)