UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NbtVI/Z3MY3tzx2ke902PxCk8Gh8DygKydBuFo8CcbA=' 
WHERE 
  key_id = 'a0b1983fbed07ad92dcadb911c6dfcaa9a5f51c17f5c656539cbe91e3e7a7cd0' 
  AND (
    token = 'NbtVI/Z3MY3tzx2ke902PxCk8Gh8DygKydBuFo8CcbA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037