UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ari1ZEMBtn1Z5fn8Pw0xEH1kVLXvxLs3ADqY7vJ9GqM=' 
WHERE 
  key_id = '5f74ce49818c6a72661b77ec049a860be34fb6c01673601680e84d4eb6eae05e' 
  AND (
    token = 'ari1ZEMBtn1Z5fn8Pw0xEH1kVLXvxLs3ADqY7vJ9GqM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030