UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZaU6z3N63ElcUCpGI7I/l68IsvNv3i38Z8jo3FLTmRw=' 
WHERE 
  key_id = 'e92ced1a8c2cbede01baf0edf70fef0cb0676ae7f5d4b84535a7279445bffb0f' 
  AND (
    token = 'ZaU6z3N63ElcUCpGI7I/l68IsvNv3i38Z8jo3FLTmRw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023