UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'PaMTfXN8ycwMu9A+ErbK6yM4r16AFqk7n8uS+RhwNzI=' 
WHERE 
  key_id = '420d82301bb8de90b53edd985d94004a7eac118f2d399bc0ce5ca655b0af6e4e' 
  AND (
    token = 'PaMTfXN8ycwMu9A+ErbK6yM4r16AFqk7n8uS+RhwNzI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044