UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AXGiYesI2vw2JBRJW7mEoos6sx1z00Idglhy34Z2Ecg='
WHERE
key_id = '9970857f2e6b13a635500f564a59ddc2bd613b02f246f36b9ba29384ce5e1530'
AND (
token = 'AXGiYesI2vw2JBRJW7mEoos6sx1z00Idglhy34Z2Ecg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)