UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'sXBG3P2dv1n8BAAeilWmK/QwJAGpOr1wC3b/KnnFaWA=' 
WHERE 
  key_id = 'f2c5a60c9ce2fecb3c359087c7c6f370bf577e7d32b1c57fd75060a2501e15ae' 
  AND (
    token = 'sXBG3P2dv1n8BAAeilWmK/QwJAGpOr1wC3b/KnnFaWA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033