UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B5huyEHef1YQNgV0fJVuFCDWR88BJYOVwZxkZXBV0KI='
WHERE
key_id = 'e7347bf3024e8e51d37f031ac22ee24eef6155c7743f5e16aeda8d25ba773f76'
AND (
token = 'B5huyEHef1YQNgV0fJVuFCDWR88BJYOVwZxkZXBV0KI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)