UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'jtGA7MjJ9Zn6LWu27EY3U/8R6BL02w7tVJ6TIGylbyw=' 
WHERE 
  key_id = '5dc204a8a0914d74ea3892c43905d6e02aa9ea66ba7b9dfd85c259bdcd3e2773' 
  AND (
    token = 'jtGA7MjJ9Zn6LWu27EY3U/8R6BL02w7tVJ6TIGylbyw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028