UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mb6i9ZMv8gVKPhxJKDtynW+FRmtAkPRYC30aKP9IQ3c=' 
WHERE 
  key_id = 'd9dc25ada1b3870df8aef077e90dcba7bec091974bf4f305fc84abdb3e526cf5' 
  AND (
    token = 'mb6i9ZMv8gVKPhxJKDtynW+FRmtAkPRYC30aKP9IQ3c=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035