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

Query time 0.00024