UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lFTRaV1XzJJ4B9/4xJ3hmz05+8mxRMLQ2TJA0VV3Gkw='
WHERE
key_id = '167bdbdebf9c23a47744843a5dad8d44c86024f713a5233d1564edcfb6191a6d'
AND (
token = 'lFTRaV1XzJJ4B9/4xJ3hmz05+8mxRMLQ2TJA0VV3Gkw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)