UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Kvcw9cjNP4N3gfO91Pet42YpLzzA4Y3fBO0SqG9gZWI=' 
WHERE 
  key_id = 'e562b31cacbb189303b39b39c29c6653d9fc66528b9fe9e1bb9fce9cd3afcfbb' 
  AND (
    token = 'Kvcw9cjNP4N3gfO91Pet42YpLzzA4Y3fBO0SqG9gZWI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028