UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '9sV7Hl6OuU/RLj5j/e1mvWLKgS3qkvgpRXZrAO+R+UY=' 
WHERE 
  key_id = 'fcd57926533e818f0034c815b4d82f7bd4303e9ea0b8d2d99e734fafd4ca7f40' 
  AND (
    token = '9sV7Hl6OuU/RLj5j/e1mvWLKgS3qkvgpRXZrAO+R+UY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041